Erreur SELECT distinct (lm.ID_R), r. * , urlphoto1, urlphoto2, urlphoto3, urlphoto4, urlphoto5, urlphoto6, urlphoto7, urlphoto8, urlphoto9, urlphoto10 FROM listemenu lm LEFT JOIN photo p ON p.ID_R = lm.ID_R LEFT JOIN resto r ON r.ID_R = lm.ID_R LEFT JOIN typemenus tm ON tm.ID_menu = lm.ID_menu LEFT JOIN service s ON s.ID_S = lm.ID_S Where tm.menuFR='Restaurant d'Hôtel' AND serviceFR='Dîner' ORDER BY rand() You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Hôtel' AND serviceFR='Dîner' ORDER BY rand()' at line 6